firstPRO is now accepting resumes for a BI Developer role in Worcester, MA. This is a direct hire role and onsite 4 days per week.
The Business Intelligence (BI) Developer role is responsible for strategically designing, implementing, and maintaining BI software and systems, including developing integrations with databases, data lakes, and warehouses. This includes selecting, designing, and rolling out BI and reporting solutions to a wide variety of end users. This role is also responsible for ensuring high levels of system availability through support functions, and in-depth testing reporting systems as well as continuous optimization of data processes and technology.
As a Business Intelligence Developer, you will work closely with stakeholders in other departments to conduct needs analyses to identify, recommend, develop, implement, and support analytics solutions that deliver essential information and analytics to their teams. You will also tune production databases to ensure high levels of data availability and mine enterprise systems and applications for knowledge and information that enhance business processes.
Responsibilities
Work with stakeholders to define business and systems requirements for information technologies, particularly in the areas of BI, analytics, and data warehousing.
- Identify, refine, and develop key BI metrics, reporting, and dashboards for various business roles and functions.
- Evaluate and recommend BI solutions, and database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
- Analyze user requirements and based on findings, design functional specifications for BI front-end applications and analytical tools.
Standards and Strategies
- Assist in the development of data management policies, procedures, and corporate data strategy.
- Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
Data Engineering
- Conduct in-depth evaluations of various data sources and their associated business functions.
- Design of databases and data warehouses to support robust historical and correlative analyses.
- Create models for new database development and/or changes to existing models.
- Produce ETL design guidelines and maintain ETL pipeline processes to ensure a robust and manageable ETL infrastructure for BI systems.
- Monitor database system details within production systems, including stored procedures and execution time, and implement efficiency improvements.
- Provide and apply quality assurance best practices for data analysis services across the organization.
- Develop integrations for BI platforms with enterprise systems and applications.
BI Development
- Design, code, test, and document all new or modified BI systems, applications, and programs.
- Develop the semantic layer, metadata, reports, and report definitions.
- Develop SQL queries and reports to meet the analytical needs of the business.
Support
- Troubleshoot, performance-tune, BI and database tools, systems, and software
- Troubleshoot and update SQL routines as needed to account for changes in underlying data and needs of the business.
- Promote BI usage to relevant departments.
- Mentor and provide leadership to members of the team.
- Design and deliver end-user training and training materials; provide technical support as necessary.
Position Requirements
Minimum Qualifications
- Bachelor’s degree in Computer Science, Data analytics, Information Systems, or Mathematics, and a minimum of 6 years of direct work experience implementing and developing BI solutions
Technical Experience
- Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling for on-premise and SaaS deployments.
- Proven experience in BI/data warehousing planning and development.
- Database Structure knowledge
- Strong understanding of relational database structures, theories, principles, and practices.
- Extensive knowledge of SQL, T-SQL, OLAP Cubes, data manipulation languages, and programming languages.
- Experience with data processing flowcharting techniques.
- Experience with tier-one applications, databases, and data warehouse support.
- Extensive experience implementing and maintaining Enterprise BI visualization tools such as Sisense, MS Power BI, Tableau, and MS SSRS
